|
|
|
| |
Portfolio Optimization 4.2 by Business Spreadsheets - Excel Templates
|
|
| |
|
| |
|
|
| List Price: |
|
$26 |
| Price: |
|
$22.10 |
| You save: |
|
$3.90 (15% off) |
| |
|
|
|
|
|
| Shipping: |
1. Free Email fulfilment (registration code and download link will be sent to your email address). No charges for shipping. |
| |
2. Extended download service (Optional) |
| |
3. Backup CD (Optional) |
| Payment: |
 |
| OS: |
Mac OS X,Mac Other,Win2000,Win7 x32,Win7 x64,Win98,WinOther,WinVista,WinVista x64,WinXP,Windows 8 |
| Download: |
Download Free Trial |
|
| Description: |
| The Portfolio Optimization template identifies the optimal capital weightings for a portfolio of financial investments that gives the desired risk and return profile based on the correlation between individual investments. The design of the portfolio optimization model enables it to be applied to either financial instrument or business stream portfolios with long and short positions. The portfolio optimization template is intuitive and flexible with help icons throughout to assist with input and interpretation of output results. Input of historical data for the analysis is supported by options to specify absolute prices or returns, number of current units held and a tool to download long time periods of financial market data for securities from the internet. Advanced optimization options include setting minimum and maximum constraints for weightings in the optimal portfolio and risk analysis options for overall volatility under the Sharpe ratio, downside risk or semi-deviation under the Sortino ratio and gain/loss under the Omega ratio. Optimization can be set to maintain at least the current level of return and specify a target return for which the probability of attaining is calculated via Monte Carlo simulation. The portfolio optimization results are displayed with weighting charts and return distributions as well as acquisition and liquidation actions required. Technical analysis is provided with back tested total return from signal trading and automatic optimization of technical period constants for each investment or the total portfolio that results in the highest back tested return. Technical analysis indicators with detailed charting and back testing analysis include simple moving average (SMA), rate of change (ROC), moving average convergence/divergence (MACD), relative strength index (RSI) and Bollinger Bands. The template is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform portfolio optimization solution. |
(Click to enlarge)
|
|
|
| |
|
|
| |
Featured Software software in this category
|
|
| |
|
Gold Price Monitor 2.1.0.8 by EverSoft |
| OS: Win2000,Win7 x32,Win7 x64,WinServer,WinVista,WinVista x64,Wi... |
Short Description:
When the gold price changed, Gold Price Monitor will notify you. |
| List Price |
Price |
You Save |
Buy Now |
| $19.95 |
$9.98 |
$9.98 (50% off) |
|
|
|
RTQuotesXL Pro 7.0.2 by OLSOFT |
| OS: WinXP,WinVista,WinVista x64,Win7 x32,Win7 x64 |
Short Description:
Download securities' real-time and delayed data directly into your workbook |
| List Price |
Price |
You Save |
Buy Now |
| $49.95 |
$34.97 |
$14.99 (30% off) |
|
|
|
BacktestingXL Pro 7.0.2 by OLSOFT |
| OS: WinXP,WinVista,WinVista x64,Win7 x32,Win7 x64 |
Short Description:
Test and evaluate your trading strategies in Excel. Simple strategy creation. |
| List Price |
Price |
You Save |
Buy Now |
| $74.95 |
$52.47 |
$22.49 (30% off) |
|
|
|
BulkQuotesXL Pro 7.0.2 by OLSOFT |
| OS: WinXP,WinVista,WinVista x64,Win7 x32,Win7 x64 |
Short Description:
Download free quotes and apply technical analysis functions in Excel worksheets. |
| List Price |
Price |
You Save |
Buy Now |
| $74.95 |
$52.47 |
$22.49 (30% off) |
|
|
|
Visual Options Analyzer 4.5.4 by OLSOFT |
| OS: WinXP,WinVista,WinVista x64,Win7 x32,Win7 x64,Windows2000,Wi... |
Short Description:
Visual Stock Options Analyzer. Build options strategies, hedging. |
| List Price |
Price |
You Save |
Buy Now |
| $69.95 |
$48.97 |
$20.99 (30% off) |
|
|
|
TraderXL Pro Package 6.1.39 by OLSOFT |
| OS: WinXP,WinVista,Win7 x32,Win7 x64 |
Short Description:
All-in-one investment solution for Microsoft Excel |
| List Price |
Price |
You Save |
Buy Now |
| $249.95 |
$174.97 |
$74.99 (30% off) |
|
|
|
| |
|
|
|
|
